package com.ruoyi.front.ap.mapper;

import com.ruoyi.front.ap.pojo.vo.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 产品分类Mapper接口
 * 
 * @author HuaQP
 * @date 2023-09-19
 */
public interface LsdMapper
{
    //产品分类汇总
    List<CategoryPlantVo> listPlantCategory(@Param("year") Long year, @Param("categoryId") Long categoryId);
    //产品销售汇总
    List<CategorySaleVo> listSaleCategory(@Param("year") Long year, @Param("categoryId") Long categoryId);

    List<MapVillageVo> listVillageVo(@Param("year") Long year, @Param("categoryId") Long categoryId);

    List<MapPlantVo> listPlantVo(@Param("year") Long year, @Param("categoryId") Long categoryId);

    List<CertifiedVo> listCertified();

    List<CategorySaleVo> listSaleByNearly5Years(Long year);

    List<VillagePlantVo> listPlantVillage(Long year);

    List<VillageSaleVo> listSaleVillage(Long year);

    List<ProductSaleVo> listSaleByProduct(@Param("year") Long year, @Param("categoryId") Long categoryId);

    List<SaleWayVo> listByWay(@Param("year") Long year, @Param("categoryId") Long categoryId);
}
